/*
 * The MIT License (MIT)
 *
 * Copyright (c) 2016 pjoc.pub, blademainer.
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
 * SOFTWARE.
 *
 */

package pub.pjoc.pay.dao;

import pub.pjoc.pay.pojo.ConfigInfo;
import org.springframework.beans.BeanUtils;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.stereotype.Repository;
import org.springframework.util.Assert;

import java.util.List;

/**
 * @author xiongyingqi
 * @since 16-6-8 下午5:37
 */
@Repository
public class ConfigDao extends BaseDao<ConfigInfo> {

  public ConfigInfo saveConfig(ConfigInfo configInfo) {
    GeneratedKeyHolder keyHolder = updateAndReturnGeneratedKeyHolder(
        "insert into config_info(config_group, config_name, config_value, config_describe) values (:configGroup, " +
            ":configName, :configValue, :configDescribe)",
        configInfo);
    ConfigInfo result = new ConfigInfo();
    BeanUtils.copyProperties(configInfo, result);
    Number key = keyHolder.getKey();
    result.setConfigId(key.longValue());
    return result;
  }

  public ConfigInfo getConfig(ConfigInfo configInfo) {
    Assert.notNull(configInfo);
    Assert.hasText(configInfo.getConfigGroup());
    Assert.hasText(configInfo.getConfigName());

    //        ConfigInfo result = jdbcTemplate
    //                .queryForObject(
    //                        "select * from config_info where config_group=:configGroup and config_name=:configName",
    //                        new BeanPropertyRowMapper<ConfigInfo>(ConfigInfo.class),
    //                        configInfo.getConfigGroup(), configInfo.getConfigName());
    ConfigInfo result = queryForObject(
        "select config_id, config_group, config_name, config_value, config_describe from config_info where " +
            "config_group=:configGroup and config_name=:configName", configInfo);
    return result;
  }

  public List<ConfigInfo> getConfigInfoListByConfigName(String configName) {
    Assert.hasText(configName);

    List<ConfigInfo> result = query(
        "select config_id, config_group, config_name, config_value, config_describe from config_info where config_name=?",
        configName);
    return result;
  }

  public int updateConfigByConfigNameAndValue(ConfigInfo configInfo) {
    Assert.notNull(configInfo, "ConfigInfo is null!");
    Assert.notNull(configInfo.getConfigGroup(), "Config group is null!");
    Assert.notNull(configInfo.getConfigName(), "Config name is null!");
    return update("update config_info set config_value=:configValue, config_describe=:configDescribe where " +
        "config_group=:configGroup and config_name=:configName", configInfo);
  }
}
